CREATE EXTERNAL TABLE jms_dwd.dwd_tab_barscan_sign_base_hi
(
    waybill_no            string COMMENT '运单编号_ef',
    signed_time           timestamp COMMENT '签收时间_ef,delivertime',
    signed_type           string COMMENT '签收类型_ef, receipttype',
    deliver_user          string COMMENT '派件员_ef',
    signed_user           string COMMENT '签收人_ef',
    scan_type             string COMMENT '扫描类型_ef,signedstatus',
    scan_user             string COMMENT '扫描雇员_ef,inputuser',
    input_time            timestamp COMMENT '入库时间_ef',
    remark                string COMMENT '备注-默认为1_ef',
    signed_site           string COMMENT '签收网点_ef',
    deliver_fee           double COMMENT '派件费-默认为0_ef',
    freight_collect       double COMMENT '到付款-默认为0_ef',
    send_station          string COMMENT '寄件站',
    destination           string COMMENT '目的地',
    pic_flag              double COMMENT '图片标识_ef,realweight',
    cod                   double COMMENT '代收款',
    fcto_month            string COMMENT '到付转月结',
    fc_currency           string COMMENT '到付款币别',
    deliver_fee_currency  string COMMENT '派件费币���',
    cod_currency          string COMMENT '代收款币别',
    cod_flag              string COMMENT '代收款已收',
    send_site             string COMMENT '寄件网点_ef',
    signed_site_2         string COMMENT '签收网点_ef_2,destsite',
    send_date             timestamp COMMENT '寄件日期',
    recepit_signed        string COMMENT '货单已签',
    site_account_flag     string COMMENT '网点对帐标识',
    pistol_id             string COMMENT '巴枪ID_ef,fcmonthlyaccount',
    transfer_flag         string COMMENT '传输标识',
    transfer_time         timestamp COMMENT '传输时间',
    transfer_user         string COMMENT '传输人',
    co_operate_src        double COMMENT '共配操作来源_ef,commision',
    input_type            string COMMENT '录入类型-默认4_ef',
    auto_produce_type     string COMMENT '自动产生类型_ef,modifystatus',
    currency              string COMMENT '币别',
    payment               string COMMENT '支付方式code_ef,collecttype',
    shifts                string COMMENT '班次',
    commision_remark      string COMMENT '提成备注',
    pcs                   double COMMENT '件数',
    charged_weight        double COMMENT '计费重量',
    contract_area         string COMMENT '派件承包区',
    agent_flag            string COMMENT '代理标识',
    signed_site_code      string COMMENT '签收网点编号_ef',
    upload_time           timestamp COMMENT '上传时间_ef',
    remark3               string COMMENT '备注3',
    scan_user_code        string COMMENT '扫描雇员编号_ef',
    send_user_code        string COMMENT '派件员编号_ef,send_deliver_usercode',
    next_station_code     string COMMENT '上下一站编号',
    source                string COMMENT '来源_ef',
    signed_cust           string COMMENT '签收人_ef,remark5',
    remark6               double COMMENT '备注6',
    list_code             string COMMENT '清单编号_ef',
    scan_site_id          bigint COMMENT '扫描网点ID_ef',
    next_station_id       bigint COMMENT '上一站/下一站ID',
    scan_user_id          bigint COMMENT '扫描雇员ID_ef',
    send_user_id          bigint COMMENT '派件员ID_ef,send_deliver_userid',
    network_type          tinyint COMMENT '扫描网点类型，1.加盟商,2.转运中心,3.集散点,4.普通网点,5.代理区,6.总部,0.其他',
    site_agent_code       string COMMENT '所属代理区code',
    site_agent_name       string COMMENT '所属代理区名称',
    site_franchisee_code  string COMMENT '所属加盟商code ',
    site_franchisee_name  string COMMENT '所属加盟商名称',
    site_transcenter_code string COMMENT '所属转运中心code',
    site_transcenter_name string COMMENT '所属转运中心名称',
    next_network_type     tinyint COMMENT '下一站网点类型，1.加盟商,2.转运中心,3.集散点,4.普通网点,5.代理区,6.总部,0.其他',
    waybill_source        string COMMENT '运单来源：GB:国标单号,BS:百世单号,BSB:百世包号,JT:极兔单号,JTB:极兔包号,Other:其它'
)
    COMMENT '操作平台-签收表小时表'
    PARTITIONED BY
        (
        dt string COMMENT '时间分区yyyy-MM-dd-HH'
        )
    stored as parquet
    LOCATION
        'hdfs://uat-bg-hdp/dw/hive/jms_dwd.db/external/dwd_tab_barscan_sign_base_hi'
